{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Test Data","Graph","Chart Data","PSW_Sheet"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":3,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph","index":1,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Test Data","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,0,5,1],[6,0,6,1],[5,2,5,5],[6,2,6,5],[7,2,7,5]]}
["Instructions:"]
["Please enter the green colored cell. This is available in the test report."]
["Please use the graph from \"Graph\" tab for the catalog."]
[]
[]
["Model Name",null,"Louver-500"]
["Application Number",null,"12345-W1"]
["Graph Title:",null,{"$f":"\"Water Penetration of \"& C6","v":"Water Penetration of Louver-500"}]
[]
[null,"Free Area\nVelocity","Carry \nOver","Include in\nRegression?","Ln(Net Weight)\n\n\n","LnXi*Yi","(LnXi)2","# of Points used for\nRegression\nAnalysis  ","Average (ln Xi)\nfor n test\npoints  ","Average Yi\nfor n test\npoints  ","Sxy","Sxx","B1","B0","Beginning point of Water Penetration"]
[null,"Yi","Xi",null,"Ln Xi",null,null,"n","Average (ln Xi)","Average (Yi)",null,null,"Sxy/Sxx"]
["Det. No.","(fpm)","(oz/FAAMCA)",null,null,null,null,null,null,null,null,null,null,null,"(fpm)"]
[1,725,1E-3,{"$f":"IF(ISNUMBER(A13),IF(C13>0,\"Yes\",\"No\"),\"-\")","v":"Yes"},{"$f":"IF(ISNUMBER($A13),IF(D13=\"Yes\",LN(C13),0),\"-\")","v":-6.9077552789821368},{"$f":"IF(ISNUMBER($A13),E13*B13,\"-\")","v":-5008.1225772620492},{"$f":"IF(ISNUMBER($A13),E13^2,\"-\")","v":47.717082994305578},{"$f":"COUNTIF(D13:D16, \"Yes\")","v":4},{"$f":"SUM(E13:E17)/H13","v":-5.1679056509486427},{"$f":"SUM(B13:B16)/H13","v":824},{"$f":"SUM(F13:F16)-SUM(B13:B16)*SUM(E13:E16)/H13","v":449.89175701710701},{"$f":"SUM(G13:G16)-(SUM(E13:E16))^2/H13","v":7.3481218263819414},{"$f":"K13/L13","v":61.225408022205329},{"$f":"J13-M13*I13","v":1140.4071320995913},{"$f":"N13+M13*LN(0.01)","v":858.45370845077525}]
[2,782,3.0000000000000001E-3,{"$f":"IF(ISNUMBER(A14),IF(C14>0,\"Yes\",\"No\"),\"-\")","v":"Yes"},{"$f":"IF(ISNUMBER($A14),IF(D14=\"Yes\",LN(C14),0),\"-\")","v":-5.8091429903140277},{"$f":"IF(ISNUMBER($A14),E14*B14,\"-\")","v":-4542.7498184255701},{"$f":"IF(ISNUMBER($A14),E14^2,\"-\")","v":33.746142281914601}]
[3,838,8.9999999999999993E-3,{"$f":"IF(ISNUMBER(A15),IF(C15>0,\"Yes\",\"No\"),\"-\")","v":"Yes"},-4.7105307016459177,{"$f":"IF(ISNUMBER($A15),E15*B15,\"-\")","v":-3947.4247279792789},22.189099491148781]
[4,951,3.9E-2,{"$f":"IF(ISNUMBER(A16),IF(C16>0,\"Yes\",\"No\"),\"-\")","v":"Yes"},-3.2441936328524905,{"$f":"IF(ISNUMBER($A16),E16*B16,\"-\")","v":-3085.2281448427184},10.52479232744064]

{"sheet":"Chart Data","index":2,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":true,"merged":[[3,1,3,4],[5,1,5,2],[5,3,5,4],[6,1,6,2],[6,3,6,4]]}
["Chart Data"]
[]
[]
["Chart Title","Model WL-AB-11 A: Size 48\" x 48\""]
[]
["Axis Titles","Horizontal:",null,{"$f":" \"Free Area Velocity (fpm)\"","v":"Free Area Velocity (fpm)"}]
[null,"Primary Vertical:",null,{"$f":" \"Water Penetration per unit Free Area (oz/ft²)\"","v":"Water Penetration per unit Free Area (oz/ft²)"}]
[]
[]
["Chart Series Description","Free\nArea\nVelocity","Water\nPenetration\nper Free Area","FA Velocity Axis Min & Max","WP Axis Min & Max"]
[null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true}]
["Series Label","Free\nArea\nVelocity","Water Penetration per Free Area"]
["Axis Minimum","-","-",{"$f":"ROUNDDOWN((B15-60),-2)","v":700},0]
["Axis Maximum","-","-",{"$f":"B45","v":1166.693405907097},{"$f":"C44","v":0.3},null,"Oz/ft2","ml/m2"]
[1,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C15)","v":858.45370845077525},{"$f":"G15","v":0.01},null,null,null,0.01,{"$f":"G15*318.327","v":3.1832700000000003}]
[2,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C16)","v":900.89192739999908},{"$f":"G16","v":0.02},null,null,null,0.02,{"$f":"G16*318.327","v":6.3665400000000005}]
[3,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C17)","v":925.71669408268906},{"$f":"G17","v":0.03},null,null,null,0.03,{"$f":"G17*318.327","v":9.549809999999999}]
[4,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C18)","v":943.33014634922301},{"$f":"G18","v":0.04},null,null,null,0.04,12.733080000000001]
[5,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C19)","v":956.9922013259594},0.05,null,null,null,0.05,15.916350000000001]
[6,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C20)","v":968.15491303191288},0.06,null,null,null,0.06,19.099619999999998]
[7,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C21)","v":977.59285130123715},7.0000000000000007E-2,null,null,null,7.0000000000000007E-2,22.282890000000002]
[8,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C22)","v":985.76836529844684},0.08,null,null,null,0.08,25.466160000000002]
[9,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C23)","v":992.97967971460287},0.09,null,null,null,0.09,28.649429999999999]
[10,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C24)","v":999.43042027518322},0.1,null,null,null,0.1,31.832700000000003]
[11,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C25)","v":1005.2658249223728},0.11,null,null,null,0.11,35.015970000000003]
[12,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C26)","v":1010.5931319811368},0.12,null,null,null,0.12,38.199239999999996]
[13,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C27)","v":1015.4937794176512},0.13,null,null,null,0.13,41.382510000000003]
[14,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C28)","v":1020.0310702504611},0.14000000000000001,null,null,null,0.14000000000000001,44.565780000000004]
[15,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C29)","v":1024.2551869578733},0.15,null,null,null,0.15,47.749049999999997]
[16,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C30)","v":1028.2065842476707},0.16,null,null,null,0.16,50.932320000000004]
[17,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C31)","v":1031.9183514545739},0.17,null,null,null,0.17,54.115590000000005]
[18,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C32)","v":1035.4178986638267},0.18,null,null,null,0.18,57.298859999999998]
[19,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C33)","v":1038.7281863467263},0.19,null,null,null,0.19,60.482129999999998]
[20,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C34)","v":1041.8686392244072},0.2,null,null,null,0.2,63.665400000000005]
[21,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C35)","v":1044.8558369331511},0.21,null,null,null,0.21,66.848669999999998]
[22,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C36)","v":1047.7040438715967},0.22,null,null,null,0.22,70.031940000000006]
[23,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C37)","v":1050.4256211723023},0.23,null,null,null,0.23,73.215209999999999]
[24,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C38)","v":1053.0313509303608},0.24,null,null,null,0.24,76.398479999999992]
[25,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C39)","v":1055.5306942011434},0.25,null,null,null,0.25,79.58175]
[26,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C40)","v":1057.9319983668752},0.26,null,null,null,0.26,82.765020000000007]
[27,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C41)","v":1060.2426653465168},0.27,null,null,null,0.27,85.94829]
[28,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C42)","v":1062.4692891996849},0.28000000000000003,null,null,null,0.28000000000000003,89.131560000000007]
[29,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C43)","v":1064.6177695731676},0.28999999999999998,null,null,null,0.28999999999999998,92.314829999999986]
[30,{"$f":"'Test Data'!$N$13+'Test Data'!$M$13*LN(C44)","v":1066.693405907097},0.3,null,null,null,0.3,95.498099999999994]
[null,{"$f":"IF(B44>1240,1300,B44+100)","v":1166.693405907097}]

{"sheet":"PSW_Sheet","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}